Welcome to pandas!

2.16 添加列的应用，求该列最高分？

import pandas as pd,numpy as np

path = r "D:\Pyobject2023\object\测试\测试素材.xlsx"

df = pd.read_excel(path)

arr=np.array(df[ "英语" ]) # 指定有缺失值的列，并把其变成一维数组

arr[np.isnan(arr)]=0 # 判定指定一维数组有缺失值的元素，并赋值为0

df[ "英语" ]=arr # 将英语一列的值再写回DateFrame

print (df)

score1=df.语文.max()

score2=df.数学.max()

score3=df.英语.max()

lit=["最高分","","",score1,score2,score3]

df.loc[len(df)]=lit

print (df)

返回：

import pandas as pd,numpy as np

path = r"D:\Pyobject2023\object\测试\测试素材.xlsx"

df = pd.read_excel(path)

arr=np.array(df[ "英语" ]) # 指定有缺失值的列，并把其变成一维数组

arr[np.isnan(arr)]=0 # 判定指定一维数组有缺失值的元素，并赋值为0

df[ "英语" ]=arr # 将英语一列的值再写回DateFrame

print (df)

score1=df.语文.sum()

score2=df.数学.sum()

score3=df.英语.sum()

lit=["总分","","",score1,score2,score3]

df.loc[len(df)]=lit

print (df)

返回：